package com.xxxt.dao;

import java.util.List;

import org.apache.ibatis.annotations.Param;

import com.xxxt.entity.College;
import com.xxxt.entity.Specialty;

public interface CollegeMapper {

	List<College> selcetAllCollegeBySchoolId(String schoolId);
	
	List<College> selcetAllCollege();
	
	List<College> selcetAllPageCollegeBySchoolId(String schoolId);
	
	College selcetOneCollegeByCollegeId(String collegeId);
	
	boolean insertCollege(College college);
	
	boolean deleteCollege(String collegeId);
	
	boolean updateCollege(@Param("collegeName") String collegeName,@Param("schoolId") String schoolId,@Param("id") String id);
	
	List<Specialty> selectStudentByTnoAndSchool(List<College> colleges);
	
	College selcetOneCollegeByName(@Param("collegeName") String collegeName,@Param("schoolId") String schoolId);
}
